Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
TIMES_SUBJECT NUMBER Yes null 22 null NO NO NO
INVOLVEMENT_COUNT NUMBER Yes null 23 null NO NO NO
SID NUMBER(38) No null 1 null NO NO NO
OBJ VARCHAR2(20) No null 2 null NO NO NO
NAME_ID NUMBER(38) Yes null 3 null NO NO NO
AGE_YEARS NUMBER Yes null 4 null NO NO NO
SEX VARCHAR2(4000) Yes null 5 null NO NO NO
RACE VARCHAR2(4000) Yes null 6 null NO NO NO
ETHNICITY VARCHAR2(4000) Yes null 7 null NO NO NO
CITIZENSHIP VARCHAR2(4000) Yes null 8 null NO NO NO
OFFICE VARCHAR2(4000) Yes null 9 null NO NO NO
DIVISION_INVOLVEMENT VARCHAR2(4000) Yes null 10 null NO NO NO
EMPLOYEE_TYPE VARCHAR2(4000) Yes null 11 null NO NO NO
EDUCATION VARCHAR2(4000) Yes null 12 null NO NO NO
MIL_SERVICE_COUNTRY VARCHAR2(108) Yes null 13 null NO NO NO
MIL_SERVICE_TYPE VARCHAR2(4000) Yes null 14 null NO NO NO
MIL_SERVICE_RANK VARCHAR2(100) Yes null 15 null NO NO NO
MIL_SERVICE_START_DATE DATE Yes null 16 null NO NO NO
MIL_SERVICE_END_DATE DATE Yes null 17 null NO NO NO
MIL_SERVICE_DISCHARGE VARCHAR2(4000) Yes null 18 null NO NO NO
IS_NGA_EMPLOYEE VARCHAR2(2) Yes null 19 null NO NO NO
CLEARANCE VARCHAR2(4000) Yes null 20 null NO NO NO
PAY_BAND VARCHAR2(4000) Yes null 21 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 06-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_MV_PARTICIPANT_INDIV
TEXT_LENGTH 7372
TEXT SELECT DISTINCT I.SID,                    I.OBJ,                    N.SID AS NAME_ID,                    ROUND((NVL(I.DOD, SYSDATE) - I.DOB) / 365) AS AGE_YEARS,                    C.SEX,                    C.RACE,                    C.ETHNICITY,                    Z.CITIZENSHIP,                    OFF.OFFICE,                    DIV.DIVISION_INVOLVEMENT,                    EMP_TYPE.EMPLOYEE_TYPE,                    E.EDUCATION,                    CTRY.DISPLAY AS MIL_SERVICE_COUNTRY,                    SERV_TYPE.DISPLAY AS MIL_SERVICE_TYPE,                    I.SERVICE_RANK AS MIL_SERVICE_RANK,                    I.SERVICE_BEGIN_DATE AS MIL_SERVICE_START_DATE,                    I.SERVICE_END_DATE AS MIL_SERVICE_END_DATE,                    DISCHARGE_TYPE.DISPLAY AS MIL_SERVICE_DISCHARGE,                    I.IS_NGA_EMPLOYEE,                    CLEAR_TYPE.DISPLAY AS CLEARANCE,                    PAY_BAND.DISPLAY AS PAY_BAND,                    NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT,                    NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT      FROM MV_PARTIC_INDIV I      LEFT JOIN MV_ACM_REF_CTRY CTRY ON I.SERVICE_COUNTRY = CTRY.ISO_3166_1_NUMERIC      LEFT JOIN MV_ACM_REFERENCE SERV_TYPE ON I.SERVICE_TYPE = SERV_TYPE.REF_KEY      LEFT JOIN MV_ACM_REFERENCE DISCHARGE_TYPE ON I.SERVICE_DISCHARGE_TYPE = DISCHARGE_TYPE.REF_KEY      LEFT JOIN MV_ACM_REFERENCE CLEAR_TYPE ON I.CLEARANCE = CLEAR_TYPE.REF_KEY      LEFT JOIN MV_ACM_REFERENCE PAY_BAND ON I.PAY_BAND = PAY_BAND.REF_KEY      LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ       AND N.IS_CURRENT = 'Y'      LEFT JOIN ( SELECT DISTINCT INDIV_PARTIC,                                  LAST_VALUE(SEX.DISPLAY)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS SEX,                                  LAST_VALUE(RACE.DISPLAY)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS RACE,                                  LAST_VALUE(ETH.DISPLAY)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS ETHNICITY,                                  LAST_VALUE(HEIGHT)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS HEIGHT,                                  LAST_VALUE(WEIGHT)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS WEIGHT,                                  LAST_VALUE(HAIR_COLOR)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS HAIR_COLOR,                                  LAST_VALUE(EYE_COLOR)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS EYE_COLOR,                                  LAST_VALUE(EFFECTIVE_DATE)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS EFFECTIVE_DATE                  FROM MV_PARTIC_INDIV_CHAR MPIC                  LEFT JOIN MV_ACM_REFERENCE RACE ON RACE.REF_KEY = MPIC.RACE                  LEFT JOIN MV_ACM_REFERENCE SEX ON SEX.REF_KEY = MPIC.SEX                  LEFT JOIN MV_ACM_REFERENCE ETH ON ETH.REF_KEY = MPIC.ETHNICITY                ) C ON I.SID = C.INDIV_PARTIC      LEFT JOIN ( SELECT INDIV_PARTIC,                         LISTAGG(CTRY.DISPLAY                                 || ' ('                                 || CIT.EFFECTIVE_DATE                                 || ')', ', ') WITHIN GROUP(                             ORDER BY COUNTRY) AS CITIZENSHIP                              FROM MV_PARTIC_INDIV_CITIZENSHIP CIT                              LEFT JOIN MV_ACM_REF_CTRY CTRY ON CTRY.ISO_3166_1_ALPHA_2 = CIT.COUNTRY                 GROUP BY INDIV_PARTIC                ) Z ON I.SID = Z.INDIV_PARTIC      LEFT JOIN ( SELECT INDIV_PARTIC,                         LISTAGG(EDUCATION_LEVEL, ', ') WITHIN GROUP(                          ORDER BY END_DATE)                         OVER(PARTITION BY INDIV_PARTIC) AS EDUCATION                  FROM MV_PARTIC_INDIV_EDUCATION                ) E ON I.SID = E.INDIV_PARTIC      LEFT JOIN ( SELECT OBJ,                         LISTAGG(PIOR.DISPLAY, ', ') WITHIN GROUP(                          ORDER BY PIOR.DISPLAY)                         OVER(PARTITION BY OBJ) AS OFFICE                  FROM MV_PARTIC_INDIV_OFFICE PIO                  LEFT JOIN MV_PARTIC_INDIV_OFFICE_REF PIOR ON PIOR.REF_KEY = PIO.OFFICE                ) OFF ON I.OBJ = OFF.OBJ      LEFT JOIN ( SELECT LISTAGG(OU.SH_DISPLAY, ';') WITHIN GROUP(                 ORDER BY SH_DISPLAY)                         OVER(PARTITION BY MPI.PARTICIPANT) AS DIVISION_INVOLVEMENT,                         MPI.PARTICIPANT                  FROM MV_PARTIC_INVOLVEMENT MPI                  LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON OU.OBJ = MPI.OBJ                ) DIV ON I.OBJ = DIV.PARTICIPANT      LEFT JOIN ( SELECT OBJ,                         LISTAGG(REF.DISPLAY, ';') WITHIN GROUP(                          ORDER BY REF.DISPLAY)                         OVER(PARTITION BY OBJ) AS EMPLOYEE_TYPE                  FROM MV_PARTIC_INDIV_OFFICE PIO                  LEFT JOIN MV_ACM_REFERENCE REF ON REF.REF_KEY = PIO.EMPLOYEE_TYPE                ) EMP_TYPE ON I.OBJ = EMP_TYPE.OBJ      LEFT JOIN ( SELECT PARTICIPANT,                         COUNT(1) SUBJECT_COUNT                                          FROM MV_PARTIC_INVOLVEMENT MPI                             WHERE INVOLVEMENT_ROLE IN ( SELECT SID                                                        FROM MV_PARTIC_ROLE_TYPE                                                         WHERE CODE = 'SUBJECT'                                                       )                 GROUP BY PARTICIPANT                ) T ON I.OBJ = T.PARTICIPANT      LEFT JOIN ( SELECT PARTICIPANT,                         COUNT(1) INVOLVEMENT_COUNT                                          FROM MV_PARTIC_INVOLVEMENT MPI                             WHERE 1 = 1                 GROUP BY PARTICIPANT                ) INV ON I.OBJ = INV.PARTICIPANT
TEXT_VC SELECT DISTINCT I.SID,                    I.OBJ,                    N.SID AS NAME_ID,                    ROUND((NVL(I.DOD, SYSDATE) - I.DOB) / 365) AS AGE_YEARS,                    C.SEX,                    C.RACE,                    C.ETHNICITY,                    Z.CITIZENSHIP,                    OFF.OFFICE,                    DIV.DIVISION_INVOLVEMENT,                    EMP_TYPE.EMPLOYEE_TYPE,                    E.EDUCATION,                    CTRY.DISPLAY AS MIL_SERVICE_COUNTRY,                    SERV_TYPE.DISPLAY AS MIL_SERVICE_TYPE,                    I.SERVICE_RANK AS MIL_SERVICE_RANK,                    I.SERVICE_BEGIN_DATE AS MIL_SERVICE_START_DATE,                    I.SERVICE_END_DATE AS MIL_SERVICE_END_DATE,                    DISCHARGE_TYPE.DISPLAY AS MIL_SERVICE_DISCHARGE,                    I.IS_NGA_EMPLOYEE,                    CLEAR_TYPE.DISPLAY AS CLEARANCE,                    PAY_BAND.DISPLAY AS PAY_BAND,                    NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT,                    NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT      FROM MV_PARTIC_INDIV I      LEFT JOIN MV_ACM_REF_CTRY CTRY ON I.SERVICE_COUNTRY = CTRY.ISO_3166_1_NUMERIC      LEFT JOIN MV_ACM_REFERENCE SERV_TYPE ON I.SERVICE_TYPE = SERV_TYPE.REF_KEY      LEFT JOIN MV_ACM_REFERENCE DISCHARGE_TYPE ON I.SERVICE_DISCHARGE_TYPE = DISCHARGE_TYPE.REF_KEY      LEFT JOIN MV_ACM_REFERENCE CLEAR_TYPE ON I.CLEARANCE = CLEAR_TYPE.REF_KEY      LEFT JOIN MV_ACM_REFERENCE PAY_BAND ON I.PAY_BAND = PAY_BAND.REF_KEY      LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ       AND N.IS_CURRENT = 'Y'      LEFT JOIN ( SELECT DISTINCT INDIV_PARTIC,                                  LAST_VALUE(SEX.DISPLAY)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS SEX,                                  LAST_VALUE(RACE.DISPLAY)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS RACE,                                  LAST_VALUE(ETH.DISPLAY)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS ETHNICITY,                                  LAST_VALUE(HEIGHT)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS HEIGHT,                                  LAST_VALUE(WEIGHT)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS WEIGHT,                                  LAST_VALUE(HAIR_COLOR)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS HAIR_COLOR,                                  LAST_VALUE(EYE_COLOR)                                  OVER(PARTITION BY INDIV_PARTIC                                       ORDER BY EFFECTIVE_DATE                                     RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING                                  ) AS EYE_COLOR,                                  LAST_VALUE(EFFECTIVE_DATE)                                  OVER(PARTITION 
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT